﻿<?xml version="1.0" encoding="utf-8"?>
<GridEXLayoutFile LayoutType="Janus.Windows.GridEX.GridEX" LayoutVersion="1.1">
    <RootTable>
        <DataMember />
        <Columns Collection="true" ElementName="Column">
            <Column0 ID="CONTACT ID/STATUS">
                <AggregateFunction>Count</AggregateFunction>
                <Caption>ID/Status</Caption>
                <CellToolTipText />
                <DataTypeCode>String</DataTypeCode>
                <BoundMode>Unbound</BoundMode>
                <DataMember>CONTACT ID/STATUS</DataMember>
                <EditTarget>Text</EditTarget>
                <HeaderToolTip>Active Lookup</HeaderToolTip>
                <Key>CONTACT ID/STATUS</Key>
                <Position>0</Position>
                <TextAlignment>Near</TextAlignment>
                <Width>162</Width>
                <WordWrap>True</WordWrap>
                <FilterRowComparison>Contains</FilterRowComparison>
                <FilterRowButtonStyle>ConditionOperatorDropDown</FilterRowButtonStyle>
                <CellStyle>
                    <BackColor>LightGreen</BackColor>
                </CellStyle>
                <HeaderStyle>
                    <FontItalic>False</FontItalic>
                </HeaderStyle>
                <DataTypeCode>String</DataTypeCode>
            </Column0>
            <Column1 ID="CONTACT COMPANY">
                <AggregateFunction>Count</AggregateFunction>
                <Caption>Company</Caption>
                <CellToolTipText />
                <DataTypeCode>String</DataTypeCode>
                <BoundMode>Unbound</BoundMode>
                <SortIndicator>Ascending</SortIndicator>
                <DataMember>CONTACT COMPANY</DataMember>
                <EditTarget>Text</EditTarget>
                <Key>CONTACT COMPANY</Key>
                <Position>1</Position>
                <TextAlignment>Near</TextAlignment>
                <Width>162</Width>
                <WordWrap>True</WordWrap>
                <FilterRowComparison>Contains</FilterRowComparison>
                <FilterRowButtonStyle>ConditionOperatorDropDown</FilterRowButtonStyle>
                <HeaderStyle>
                    <FontItalic>False</FontItalic>
                </HeaderStyle>
                <DataTypeCode>String</DataTypeCode>
            </Column1>
            <Column2 ID="CONTACT Contact">
                <Caption>Contact</Caption>
                <CellToolTipText />
                <DataTypeCode>String</DataTypeCode>
                <BoundMode>Unbound</BoundMode>
                <DataMember>CONTACT CONTACT</DataMember>
                <EditTarget>Text</EditTarget>
                <Key>CONTACT Contact</Key>
                <Position>2</Position>
                <TextAlignment>Near</TextAlignment>
                <Width>201</Width>
                <WordWrap>True</WordWrap>
                <FilterRowComparison>Contains</FilterRowComparison>
                <FilterRowButtonStyle>ConditionOperatorDropDown</FilterRowButtonStyle>
                <HeaderStyle>
                    <FontItalic>False</FontItalic>
                </HeaderStyle>
                <DataTypeCode>String</DataTypeCode>
            </Column2>
            <Column3 ID="CONTACT PHONE">
                <Caption>Phone</Caption>
                <CellToolTipText />
                <DataTypeCode>String</DataTypeCode>
                <BoundMode>Unbound</BoundMode>
                <DataMember>CONTACT PHONE</DataMember>
                <EditTarget>Text</EditTarget>
                <Key>CONTACT PHONE</Key>
                <Position>5</Position>
                <Width>145</Width>
                <FilterRowButtonStyle>ConditionOperatorDropDown</FilterRowButtonStyle>
                <HeaderStyle>
                    <FontItalic>False</FontItalic>
                </HeaderStyle>
                <DataTypeCode>String</DataTypeCode>
            </Column3>
            <Column4 ID="CONTACT ADDRESS_1">
                <Caption>Address 1</Caption>
                <CellToolTipText />
                <DataTypeCode>String</DataTypeCode>
                <BoundMode>Unbound</BoundMode>
                <DataMember>CONTACT ADDRESS_1</DataMember>
                <EditTarget>Text</EditTarget>
                <Key>CONTACT ADDRESS_1</Key>
                <Position>6</Position>
                <Width>145</Width>
                <FilterRowComparison>Contains</FilterRowComparison>
                <FilterRowButtonStyle>ConditionOperatorDropDown</FilterRowButtonStyle>
                <HeaderStyle>
                    <FontItalic>False</FontItalic>
                </HeaderStyle>
                <DataTypeCode>String</DataTypeCode>
            </Column4>
            <Column5 ID="CONTACT STATE">
                <Caption>State</Caption>
                <CellToolTipText />
                <DataTypeCode>String</DataTypeCode>
                <BoundMode>Unbound</BoundMode>
                <DataMember>CONTACT STATE</DataMember>
                <EditTarget>Text</EditTarget>
                <Key>CONTACT STATE</Key>
                <Position>7</Position>
                <Width>146</Width>
                <FilterRowComparison>Contains</FilterRowComparison>
                <FilterRowButtonStyle>ConditionOperatorDropDown</FilterRowButtonStyle>
                <HeaderStyle>
                    <FontItalic>False</FontItalic>
                </HeaderStyle>
                <DataTypeCode>String</DataTypeCode>
            </Column5>
            <Column6 ID="CONTACT CITY">
                <Caption>City</Caption>
                <CellToolTipText />
                <DataTypeCode>String</DataTypeCode>
                <BoundMode>Unbound</BoundMode>
                <DataMember>CONTACT CITY</DataMember>
                <EditTarget>Text</EditTarget>
                <Key>CONTACT CITY</Key>
                <Position>8</Position>
                <Width>144</Width>
                <FilterRowComparison>Contains</FilterRowComparison>
                <FilterRowButtonStyle>ConditionOperatorDropDown</FilterRowButtonStyle>
                <HeaderStyle>
                    <FontItalic>False</FontItalic>
                </HeaderStyle>
                <DataTypeCode>String</DataTypeCode>
            </Column6>
            <Column7 ID="CONTACT ZIP_CODE">
                <Caption>ZIP Code</Caption>
                <CellToolTipText />
                <DataTypeCode>String</DataTypeCode>
                <BoundMode>Unbound</BoundMode>
                <DataMember>CONTACT ZIP_CODE</DataMember>
                <EditTarget>Text</EditTarget>
                <Key>CONTACT ZIP_CODE</Key>
                <Position>9</Position>
                <Width>54</Width>
                <FilterRowComparison>Contains</FilterRowComparison>
                <FilterRowButtonStyle>ConditionOperatorDropDown</FilterRowButtonStyle>
                <HeaderStyle>
                    <FontItalic>False</FontItalic>
                </HeaderStyle>
                <DataTypeCode>String</DataTypeCode>
            </Column7>
            <Column8 ID="CONTACT AEM Opt Out">
                <Caption>AEM Opt Out</Caption>
                <CellToolTipText />
                <DataTypeCode>Boolean</DataTypeCode>
                <CheckBoxTriState>True</CheckBoxTriState>
                <BoundMode>Unbound</BoundMode>
                <ColumnType>CheckBox</ColumnType>
                <DataMember>CONTACT AEM Opt Out</DataMember>
                <EditTarget>Text</EditTarget>
                <EditType>CheckBox</EditType>
                <FilterEditType>Combo</FilterEditType>
                <Key>CONTACT AEM Opt Out</Key>
                <Position>10</Position>
                <Width>85</Width>
                <FilterRowComparison>Equal</FilterRowComparison>
                <FilterRowButtonStyle>ConditionOperatorDropDown</FilterRowButtonStyle>
                <HeaderStyle>
                    <FontItalic>False</FontItalic>
                </HeaderStyle>
                <DataTypeCode>Boolean</DataTypeCode>
            </Column8>
            <Column9 ID="CONTACT AEM Replied directly to be removed">
                <Caption>AEM Replied directly to be removed</Caption>
                <CellToolTipText />
                <DataTypeCode>Boolean</DataTypeCode>
                <CheckBoxTriState>True</CheckBoxTriState>
                <BoundMode>Unbound</BoundMode>
                <ColumnType>CheckBox</ColumnType>
                <DataMember>CONTACT AEM Replied directly to be removed</DataMember>
                <EditTarget>Text</EditTarget>
                <EditType>CheckBox</EditType>
                <FilterEditType>Combo</FilterEditType>
                <Key>CONTACT AEM Replied directly to be removed</Key>
                <Position>12</Position>
                <Width>93</Width>
                <FilterRowComparison>Equal</FilterRowComparison>
                <FilterRowButtonStyle>ConditionOperatorDropDown</FilterRowButtonStyle>
                <HeaderStyle>
                    <FontItalic>False</FontItalic>
                </HeaderStyle>
                <DataTypeCode>Boolean</DataTypeCode>
            </Column9>
            <Column10 ID="CONTACT AEM Bounce Back">
                <Caption>AEM Bounce Back</Caption>
                <CellToolTipText />
                <DataTypeCode>Boolean</DataTypeCode>
                <CheckBoxTriState>True</CheckBoxTriState>
                <BoundMode>Unbound</BoundMode>
                <ColumnType>CheckBox</ColumnType>
                <DataMember>CONTACT AEM Bounce Back</DataMember>
                <EditTarget>Text</EditTarget>
                <EditType>CheckBox</EditType>
                <FilterEditType>Combo</FilterEditType>
                <HeaderToolTip>Active Lookup</HeaderToolTip>
                <Key>CONTACT AEM Bounce Back</Key>
                <Position>11</Position>
                <Width>90</Width>
                <FilterRowComparison>Equal</FilterRowComparison>
                <FilterRowButtonStyle>ConditionOperatorDropDown</FilterRowButtonStyle>
                <CellStyle>
                    <BackColor>LightGreen</BackColor>
                </CellStyle>
                <HeaderStyle>
                    <FontItalic>False</FontItalic>
                </HeaderStyle>
                <DataTypeCode>Boolean</DataTypeCode>
            </Column10>
            <Column11 ID="CONTACT LAST_NAME">
                <Caption>Last Name</Caption>
                <CellToolTipText />
                <DataTypeCode>String</DataTypeCode>
                <BoundMode>Unbound</BoundMode>
                <DataMember>CONTACT LAST_NAME</DataMember>
                <EditTarget>Text</EditTarget>
                <Key>CONTACT LAST_NAME</Key>
                <Position>4</Position>
                <Width>143</Width>
                <FilterRowComparison>Contains</FilterRowComparison>
                <FilterRowButtonStyle>ConditionOperatorDropDown</FilterRowButtonStyle>
                <HeaderStyle>
                    <FontItalic>False</FontItalic>
                </HeaderStyle>
                <DataTypeCode>String</DataTypeCode>
            </Column11>
            <Column12 ID="CONTACT FIRST_NAME">
                <Caption>First Name</Caption>
                <CellToolTipText />
                <DataTypeCode>String</DataTypeCode>
                <BoundMode>Unbound</BoundMode>
                <DataMember>CONTACT FIRST_NAME</DataMember>
                <EditTarget>Text</EditTarget>
                <Key>CONTACT FIRST_NAME</Key>
                <Position>3</Position>
                <Width>131</Width>
                <FilterRowComparison>Contains</FilterRowComparison>
                <FilterRowButtonStyle>ConditionOperatorDropDown</FilterRowButtonStyle>
                <HeaderStyle>
                    <FontItalic>False</FontItalic>
                </HeaderStyle>
                <DataTypeCode>String</DataTypeCode>
            </Column12>
        </Columns>
        <AllowEdit>False</AllowEdit>
        <FormatConditions Collection="true" ElementName="Condition">
            <Condition0 ID="CA California Contacts">
                <ColIndex>5</ColIndex>
                <ConditionOperator>Contains</ConditionOperator>
                <FormatStyle>
                    <BackColor>255, 255, 192</BackColor>
                    <ForeColor>0, 0, 0</ForeColor>
                    <BackColorGradient>0, 0, 0, 0</BackColorGradient>
                    <Font>Arial, 8pt</Font>
                    <FontBold>False</FontBold>
                    <FontItalic>False</FontItalic>
                    <FontName>Arial</FontName>
                    <FontSize>8</FontSize>
                    <FontStrikeout>False</FontStrikeout>
                    <FontUnderline>False</FontUnderline>
                </FormatStyle>
                <Value1>CA</Value1>
                <Value2> </Value2>
                <Key>CA California Contacts</Key>
            </Condition0>
            <Condition1 ID="City = New York">
                <ColIndex>6</ColIndex>
                <ConditionOperator>Contains</ConditionOperator>
                <FormatStyle>
                    <BackColor>255, 192, 192</BackColor>
                    <ForeColor>0, 0, 0</ForeColor>
                    <BackColorGradient>0, 0, 0, 0</BackColorGradient>
                    <Font>Arial, 8pt</Font>
                    <FontBold>False</FontBold>
                    <FontItalic>False</FontItalic>
                    <FontName>Arial</FontName>
                    <FontSize>8</FontSize>
                    <FontStrikeout>False</FontStrikeout>
                    <FontUnderline>False</FontUnderline>
                </FormatStyle>
                <Value1>New York</Value1>
                <Value2> </Value2>
                <Key>City = New York</Key>
            </Condition1>
            <Condition2 ID="Zip Code is Empty">
                <ColIndex>7</ColIndex>
                <ConditionOperator>IsEmpty</ConditionOperator>
                <FormatStyle>
                    <BackColor>192, 255, 255</BackColor>
                    <ForeColor>0, 0, 0</ForeColor>
                    <BackColorGradient>0, 0, 0, 0</BackColorGradient>
                    <Font>Arial, 8pt</Font>
                    <FontBold>False</FontBold>
                    <FontItalic>False</FontItalic>
                    <FontName>Arial</FontName>
                    <FontSize>8</FontSize>
                    <FontStrikeout>False</FontStrikeout>
                    <FontUnderline>False</FontUnderline>
                </FormatStyle>
                <Value1> </Value1>
                <Value2> </Value2>
                <Key>Zip Code is Empty</Key>
            </Condition2>
        </FormatConditions>
        <GroupCondition />
        <GroupHeaderTotals Collection="true" ElementName="GroupHeaderTotal">
            <GroupHeaderTotal0 ID="CONTACT CONTACT">
                <ColIndex>2</ColIndex>
                <AggregateFunction>Count</AggregateFunction>
                <TotalFormatString>n0</TotalFormatString>
                <TotalPrefix />
                <TotalSuffix />
                <Key>CONTACT CONTACT</Key>
                <ColumnAlign>2</ColumnAlign>
                <FormatStyle>
                    <BackColor>Aqua</BackColor>
                    <TextAlignment>Center</TextAlignment>
                </FormatStyle>
            </GroupHeaderTotal0>
            <GroupHeaderTotal1 ID="CONTACT COMPANY">
                <ColIndex>1</ColIndex>
                <AggregateFunction>Count</AggregateFunction>
                <TotalFormatString>n0</TotalFormatString>
                <TotalPrefix />
                <TotalSuffix />
                <Key>CONTACT COMPANY</Key>
                <ColumnAlign>1</ColumnAlign>
                <FormatStyle>
                    <BackColor>Aqua</BackColor>
                    <TextAlignment>Center</TextAlignment>
                </FormatStyle>
            </GroupHeaderTotal1>
            <GroupHeaderTotal2 ID="CONTACT ID/STATUS">
                <ColIndex>0</ColIndex>
                <AggregateFunction>Count</AggregateFunction>
                <TotalFormatString>n0</TotalFormatString>
                <TotalPrefix />
                <TotalSuffix />
                <Key>CONTACT ID/STATUS</Key>
                <ColumnAlign>0</ColumnAlign>
                <FormatStyle>
                    <BackColor>Aqua</BackColor>
                    <TextAlignment>Center</TextAlignment>
                </FormatStyle>
            </GroupHeaderTotal2>
        </GroupHeaderTotals>
        <Tag>ImpactV6|</Tag>
    </RootTable>
    <SearchColumnIndex>2</SearchColumnIndex>
    <RowWithErrorsFormatStyle>
        <PredefinedStyle>RowWithErrorsFormatStyle</PredefinedStyle>
    </RowWithErrorsFormatStyle>
    <LinkFormatStyle>
        <PredefinedStyle>LinkFormatStyle</PredefinedStyle>
    </LinkFormatStyle>
    <CardCaptionFormatStyle>
        <PredefinedStyle>CardCaptionFormatStyle</PredefinedStyle>
    </CardCaptionFormatStyle>
    <FilterRowFormatStyle>
        <BackColor>255, 255, 192</BackColor>
        <PredefinedStyle>FilterRowFormatStyle</PredefinedStyle>
    </FilterRowFormatStyle>
    <GroupByBoxFormatStyle>
        <BackColor>200, 216, 235</BackColor>
        <PredefinedStyle>GroupByBoxFormatStyle</PredefinedStyle>
    </GroupByBoxFormatStyle>
    <GroupByBoxInfoFormatStyle>
        <PredefinedStyle>GroupByBoxInfoFormatStyle</PredefinedStyle>
    </GroupByBoxInfoFormatStyle>
    <GroupRowFormatStyle>
        <BackColor>Info</BackColor>
        <BackColorGradient>Info</BackColorGradient>
        <PredefinedStyle>GroupRowFormatStyle</PredefinedStyle>
    </GroupRowFormatStyle>
    <HeaderFormatStyle>
        <BackColor>241, 241, 241</BackColor>
        <ForeColor>64, 64, 64</ForeColor>
        <PredefinedStyle>HeaderFormatStyle</PredefinedStyle>
    </HeaderFormatStyle>
    <PreviewRowFormatStyle>
        <PredefinedStyle>PreviewRowFormatStyle</PredefinedStyle>
    </PreviewRowFormatStyle>
    <RowFormatStyle>
        <BackColor>255, 153, 0</BackColor>
        <PredefinedStyle>RowFormatStyle</PredefinedStyle>
    </RowFormatStyle>
    <SelectedFormatStyle>
        <BackColor>200, 235, 252</BackColor>
        <ForeColor>0, 0, 0</ForeColor>
        <BackColorGradient>193, 219, 252</BackColorGradient>
        <PredefinedStyle>SelectedFormatStyle</PredefinedStyle>
        <BackgroundGradientMode>Vertical</BackgroundGradientMode>
    </SelectedFormatStyle>
    <SelectedInactiveFormatStyle>
        <PredefinedStyle>SelectedInactiveFormatStyle</PredefinedStyle>
    </SelectedInactiveFormatStyle>
    <TotalRowFormatStyle>
        <BackColor>200, 216, 235</BackColor>
        <PredefinedStyle>TotalRowFormatStyle</PredefinedStyle>
    </TotalRowFormatStyle>
    <FocusCellFormatStyle>
        <BackColor>200, 235, 252</BackColor>
        <ForeColor>0, 0, 0</ForeColor>
        <BackColorGradient>193, 219, 252</BackColorGradient>
        <PredefinedStyle>FocusCellFormatStyle</PredefinedStyle>
        <BackgroundGradientMode>Vertical</BackgroundGradientMode>
    </FocusCellFormatStyle>
    <WatermarkImage />
    <AlternatingColors>True</AlternatingColors>
    <GridLineStyle>Solid</GridLineStyle>
    <TreeLineColor>Blue</TreeLineColor>
    <BorderStyle>None</BorderStyle>
    <ThemedAreas>ScrollBars, EditControls, Headers, TreeGliphs, GroupRows, ControlBorder, Cards, Gridlines, CheckBoxes</ThemedAreas>
    <BackColor>White</BackColor>
    <Font>Microsoft Sans Serif, 8.25pt</Font>
    <ScrollBarWidth>16</ScrollBarWidth>
    <VisualStyle>Office2010</VisualStyle>
    <OfficeColorScheme>Custom</OfficeColorScheme>
    <OfficeCustomColor>190, 190, 190</OfficeCustomColor>
    <VisualStyleAreas>
        <CardsStyle>Office2010</CardsStyle>
        <ControlBorderStyle>Office2010</ControlBorderStyle>
        <GroupByBoxStyle>Office2010</GroupByBoxStyle>
        <GroupRowsStyle>Office2010</GroupRowsStyle>
        <HeadersStyle>Office2010</HeadersStyle>
        <TreeGliphsStyle>Office2010</TreeGliphsStyle>
        <EditControlsStyle>Office2010</EditControlsStyle>
        <ScrollBarsStyle>Office2010</ScrollBarsStyle>
    </VisualStyleAreas>
    <IncrementalSearchMode>AllCharacters</IncrementalSearchMode>
    <AllowDelete>True</AllowDelete>
    <AllowEdit>False</AllowEdit>
    <AllowRemoveColumns>True</AllowRemoveColumns>
    <AutomaticSort>False</AutomaticSort>
    <ColumnAutoResize>True</ColumnAutoResize>
    <ContinuousScroll>False</ContinuousScroll>
    <GroupByBoxVisible>False</GroupByBoxVisible>
    <GroupTotals>ExpandedGroup</GroupTotals>
    <HideSelection>Highlight</HideSelection>
    <SelectionMode>MultipleSelection</SelectionMode>
    <TotalRow>True</TotalRow>
    <EnterKeyBehavior>NextCell</EnterKeyBehavior>
    <BuiltInTexts ID="LocalizableStrings" Collection="true">
        <GroupByBoxInfo>Click here to add a group</GroupByBoxInfo>
        <FilterRowInfoText> </FilterRowInfoText>
        <FilterRowConditionEqual>Equal to (=)</FilterRowConditionEqual>
        <FilterRowConditionNotEqual>Not Equal to (!=)</FilterRowConditionNotEqual>
        <FilterRowConditionGreaterThan>Greater Than</FilterRowConditionGreaterThan>
        <FilterRowConditionGreaterThanOrEqual>Greater Than or Equal To</FilterRowConditionGreaterThanOrEqual>
        <FilterRowConditionLessThan>Less Than</FilterRowConditionLessThan>
        <FilterRowConditionLessThanOrEqual>Less Than or Equal To</FilterRowConditionLessThanOrEqual>
        <FilterRowConditionContains>Contains</FilterRowConditionContains>
        <FilterRowConditionNotContains>Does Not Contain</FilterRowConditionNotContains>
        <FilterRowConditionEndsWith>Ends With</FilterRowConditionEndsWith>
        <FilterRowConditionBeginsWith>Starts With</FilterRowConditionBeginsWith>
        <FilterRowConditionIsEmpty>Does Not Contain Data</FilterRowConditionIsEmpty>
        <FilterRowConditionNotIsEmpty>Contains Data</FilterRowConditionNotIsEmpty>
    </BuiltInTexts>
    <TotalRowPosition>BottomFixed</TotalRowPosition>
</GridEXLayoutFile>